
#delimit ;

***********************************************************************
    Label : FIPS County of Residence 
	Rows: 296982
	Columns : 5
	ASCII File Date: December 17, 2021 
***********************************************************************	;


infix
	RLS10		1 - 1 		 YEAR10		2 - 5		FAMID10		6 - 10
	STATE10 	11 - 12		COUNTY10 	13 - 15
using P:\restricted\14_County-Identifiers\FIPSCnty10.txt, clear
;
label variable RLS10 		"RELEASE NUMBER";
label variable YEAR10		"INTERVIEW NUMBER";
label variable FAMID10		"FAMILY INTERVIEW NUMBER";
label variable STATE10		"FIPS STATE 2010" ;
label variable COUNTY10		"FIPS COUNTY/COUNTRY 2010";

#delimit cr
rename YEAR10 year
rename FAMID10 intnum
rename STATE10 state_fips
rename COUNTY10 county_fips

g statecounty = state_fips*1000 + county_fips
replace statecounty =	. if state_fips > 60
replace statecounty = . if county_fips > 900
drop RLS10
save "U:\dtafiles\state_county_clean.dta", replace
